﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="ShowIt.aspx.vb" Inherits="TeachersWorkSheets.ShowIt" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style1
        {
            width: 100%;
            margin-left: 177px;
        }
        .style2
        {
        }
        .style3
        {
            width: 308px;
        }
        .style4
        {
            width: 240px;
        }
        .style5
        {
            width: 58%;
            margin-left: 180px;
        }
        .style6
        {
            width: 380px;
        }
        .style7
        {
        }
        .style8
        {
        }
        .style9
        {
            width: 67px;
        }
        .style10
        {
        }
        .style11
        {
            height: 24px;
        }
        .style12
        {
            width: 380px;
            height: 24px;
        }
        .style13
        {
            height: 21px;
        }
        .style14
        {
            font-family: "Segoe UI Semibold";
            font-size: medium;
            color: #000000;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        <br />
    </p>
    <table class="style1">
        <tr>
            <td class="style2" colspan="3" height="40" 
                
                
                style="padding-top: 0px; border: 2px solid #006699; background-color: #8DC2DC; color: #000000; font-size: 20px; font-family: Arial, Helvetica, sans-serif; text-align: center;">
                Activity Sheet Details</td>
            <td class="style6">
                &nbsp;</td>
        </tr>
        <tr>
            <td bgcolor="#99CCFF" class="style4" 
                
                style="background-position: center center; padding-top: 0px; border: 2px solid #006699; background-image: url('Images/pdf_icon.jpg');" 
                colspan="2">
                &nbsp;</td>
            <td class="style3" style="padding-top: 0px; border: 2px solid #006699">
                <asp:SqlDataSource ID="ShowitDataSource" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SheetsConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:SheetsConnectionString.ProviderName %>" 
                    SelectCommand="SELECT [ShtFile], [ShtName], [ShtCreator], [ShtDescription], [ShtRate], [ShtSubject], [ShtGrade], [ShtRegDate], [ID] FROM [ActivitySheet] WHERE ([ID] = ?)">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td class="style6">
                &nbsp;</td>
        </tr>
        <tr>
            <td bgcolor="#99CCFF" class="style8" 
                
                style="padding-top: 0px; border: 2px solid #006699; background-color: #336699; color: #FFFFFF; font-size: 17px;" 
                align="center">
                Descriptiopn</td>
            <td bgcolor="#99CCFF" class="style10" 
                style="padding-top: 0px; border: 2px solid #006699" colspan="2">
                &nbsp;</td>
            <td class="style6">
                &nbsp;</td>
        </tr>
        <tr>
            <td bgcolor="#CCFFFF" class="style11" 
                style="padding-top: 0px; border: 2px solid #006699" colspan="3">
                </td>
            <td class="style12">
                </td>
        </tr>
        <tr>
            <td bgcolor="White" class="style11" 
                style="padding-top: 0px; " colspan="3">
                &nbsp;</td>
            <td class="style12">
                &nbsp;</td>
        </tr>
        <tr>
            <td bgcolor="White" class="style11" 
                style="padding-top: 0px; " colspan="3">
                &nbsp;</td>
            <td class="style12">
                &nbsp;</td>
        </tr>
    </table>
    <br />
    <table class="style5">
        <tr>
            <td class="style9">
                <asp:SqlDataSource ID="likedatasource" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SheetsConnectionString %>" 
                    InsertCommand="INSERT INTO usersheetLiking(Liker, sheetid) VALUES (?, ?)" 
                    ProviderName="<%$ ConnectionStrings:SheetsConnectionString.ProviderName %>" 
                    SelectCommand="SELECT [Author], [Title], [CommentBody], [Sheet_fkID] FROM [Comments] WHERE ([Sheet_fkID] = ?)" 
                    UpdateCommand="UPDATE ActivitySheet SET shtlike = shtlike + 1 WHERE (ID = ?)">
                    <InsertParameters>
                        <asp:SessionParameter Name="?" SessionField="username" />
                        <asp:QueryStringParameter Name="?" QueryStringField="id" />
                    </InsertParameters>
                    <SelectParameters>
                        <asp:QueryStringParameter Name="Sheet_fkID" QueryStringField="ID" 
                            Type="Int32" />
                    </SelectParameters>
                    <UpdateParameters>
                        <asp:QueryStringParameter Name="?" QueryStringField="id" />
                    </UpdateParameters>
                </asp:SqlDataSource>
            </td>
            <td class="style8">
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style9">
                <asp:Label ID="lb_comTitle" runat="server" Font-Bold="True" ForeColor="Black" 
                    Text="Title"></asp:Label>
                :</td>
            <td class="style8">
                <asp:TextBox ID="tb_TitleCom" runat="server" BorderColor="#CCFFFF"></asp:TextBox>
            </td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style7" colspan="4">
                <asp:TextBox ID="tb_ComntBody" runat="server" ForeColor="Black" 
                    Height="143px" TextMode="MultiLine" Width="537px" BorderColor="#CCFFFF" 
                    BorderWidth="3px"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td class="style13" colspan="2">
                <asp:Button ID="btn_AddComnt" runat="server" Text="Add Comment" />
            </td>
            <td class="style13">
                &nbsp;</td>
            <td class="style13">
                </td>
        </tr>
        <tr>
            <td class="style8" colspan="2">
                <br />
                <asp:LinkButton ID="LinkButton1" runat="server" Width="49px">Like</asp:LinkButton>
                <br />
                <br />
                <span class="style14">Rate this Activity Sheet:<asp:Rating ID="Rating1" 
                    runat="server" CurrentRating="2" EmptyStarCssClass="off-star" 
                    FilledStarCssClass="star" StarCssClass="star" WaitingStarCssClass="off-star">
                </asp:Rating>
                <br />
                <br />
                <asp:Button ID="btn_SaveRating" runat="server" Text="Save my Rating" />
                <br />
                </span>
                <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
                </asp:ToolkitScriptManager>
            </td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    <br />
</asp:Content>
